MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Artist Alpha Sort = 20312

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Is Public Domain, Object Name, Title, Object Date, Object Begin Date, Object End Date, Medium, Dimensions, Credit Line, Classification

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Metadata Date Repository
215668 215668 53.664.37 0 1 343093 Drawings and Prints 11 Drawing Ornament & Architecture 13828 Costume Design           Artist 2   Pierre-Numa Bassaget, called Numa French, active 1830–54   Numa, Pierre-Numa Bassaget, called 20312 French 2 1830 1854 1836–37 1836 1837 Pen and brown ink, pen and black ink, brush and brown wash, graphite 33418 9 1/2 x 5 7/8 in. (24.2 x 15 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1953                       Drawings|Ornament & Architecture 671   http://www.metmuseum.org/art/collection/search/343093 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
215669 215669 65.646.10 0 1 343094 Drawings and Prints 11 Drawing 23 Fashion Drawing with a Woman Seated in a Chair with a Boy and Girl           Artist 2   Pierre-Numa Bassaget, called Numa French, active 1830–54   Numa, Pierre-Numa Bassaget, called 20312 French 2 1830 1854 19th century 1800 1899 Graphite and watercolor 29083 6 5/8 x 5 1/4 in. (16.8 x 13.3 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1965                       Drawings 9   http://www.metmuseum.org/art/collection/search/343094 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
215775 215775 53.664.38 0 1 343200 Drawings and Prints 11 Drawing 23 Costume Design           Artist 2   Pierre-Numa Bassaget, called Numa French, active 1830–54   Numa, Pierre-Numa Bassaget, called 20312 French 2 1830 1854 1836–37 1836 1837 Pen and brown ink, brush and brown wash, graphite 33481 9 1/2 x 5 7/8 in. (24.2 x 15 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1953                       Drawings 9   http://www.metmuseum.org/art/collection/search/343200 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
215776 215776 53.664.39 0 1 343201 Drawings and Prints 11 Drawing 23 Costume Design           Artist 2   Pierre-Numa Bassaget, called Numa French, active 1830–54   Numa, Pierre-Numa Bassaget, called 20312 French 2 1830 1854 1836–37 1836 1837 Pen and brown ink, watercolor, graphite 33482 9 1/2 x 5 7/8 in. (24.2 x 15 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1953                       Drawings 9   http://www.metmuseum.org/art/collection/search/343201 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
215777 215777 53.664.40 0 1 343202 Drawings and Prints 11 Drawing 23 Costume Design           Artist 2   Pierre-Numa Bassaget, called Numa French, active 1830–54   Numa, Pierre-Numa Bassaget, called 20312 French 2 1830 1854 1836–37 1836 1837 Pen and brown ink, brush and brown wash, graphite 33481 9 5/8 x 5 7/8 in. (24.5 x 15 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1953                       Drawings 9   http://www.metmuseum.org/art/collection/search/343202 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
221548 221548 58.512.1 0 1 349100 Drawings and Prints 11 Drawing 23 "At the Railroad Station"           Artist 2   Pierre-Numa Bassaget, called Numa French, active 1830–54   Numa, Pierre-Numa Bassaget, called 20312 French 2 1830 1854 1850–59 1850 1859 Graphite, black and red chalk, heightened with white 34931 12 3/8 x 16 3/4 in. (31.4 x 42.6 cm) Top corners rounded. The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1958                       Drawings 9   http://www.metmuseum.org/art/collection/search/349100 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
221551 221551 58.512.2 0 1 349103 Drawings and Prints 11 Drawing 23 Crowd Leaving a Theatre [?]           Artist 2   Pierre-Numa Bassaget, called Numa French, active 1830–54   Numa, Pierre-Numa Bassaget, called 20312 French 2 1830 1854 19th century 1800 1899 Graphite, black and red chalk, heightened with white 34931 12 1/2 x 16 7/8 in. (31.7 x 42.8 cm). Top corners rounded. The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1958                       Drawings 9   http://www.metmuseum.org/art/collection/search/349103 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1
232159 232159 67.539.46 0 0 359905 Drawings and Prints 11 Print 731 The Fashion for Winter           Artist 2   Pierre-Numa Bassaget, called Numa French, active 1830–54   Numa, Pierre-Numa Bassaget, called 20312 French 2 1830 1854 ca. 1840 1835 1845 Hand-colored lithograph 3394   Purchase, Harry G. Friedman Bequest, 1967                       Prints 13   http://www.metmuseum.org/art/collection/search/359905 4/23/2018 8:00:01 AM Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 243.614ms · Data license: CC0 · Data source: metmuseum/openaccess